Shootings-2018.csv contains every single incident of United States in 2018. From the data set, we can tell these following things.
As whole, 340 shootings occured in United States in 2018, and these indidents killed 373 people. The most impacted city was Chicago, the number of killed people is 13 and 122 people got injured. This time, the impact was calculated by following equasion.
impact = num_killed * 3 + num_injured
As a state level, the most dangerous state is California. The impact value was 286.(death: 50, injuries: 136)
Summary Table is as following.
| state | sum_killed | sum_injured | sum_impact | mean_impact |
|---|---|---|---|---|
| Alabama | 12 | 55 | 91 | 6.500000 |
| Arizona | 4 | 5 | 17 | 8.500000 |
| Arkansas | 7 | 17 | 38 | 6.333333 |
| California | 50 | 136 | 286 | 8.171429 |
| Colorado | 9 | 27 | 54 | 6.750000 |
| Connecticut | 0 | 8 | 8 | 4.000000 |
| Delaware | 5 | 0 | 15 | 15.000000 |
| District of Columbia | 2 | 23 | 29 | 4.833333 |
| Florida | 48 | 132 | 276 | 9.200000 |
| Georgia | 3 | 33 | 42 | 5.250000 |
| Illinois | 21 | 150 | 213 | 6.085714 |
| Indiana | 10 | 27 | 57 | 7.125000 |
| Kansas | 1 | 11 | 14 | 7.000000 |
| Kentucky | 7 | 25 | 46 | 11.500000 |
| Louisiana | 15 | 50 | 95 | 7.307692 |
| Maryland | 13 | 31 | 70 | 7.777778 |
| Massachusetts | 0 | 4 | 4 | 4.000000 |
| Michigan | 10 | 28 | 58 | 7.250000 |
| Minnesota | 1 | 14 | 17 | 5.666667 |
| Mississippi | 1 | 17 | 20 | 6.666667 |
| Missouri | 12 | 52 | 88 | 6.285714 |
| Nebraska | 1 | 16 | 19 | 6.333333 |
| Nevada | 3 | 15 | 24 | 6.000000 |
| New Jersey | 4 | 54 | 66 | 6.600000 |
| New Mexico | 5 | 4 | 19 | 9.500000 |
| New York | 5 | 53 | 68 | 5.230769 |
| North Carolina | 14 | 37 | 79 | 7.181818 |
| Ohio | 13 | 46 | 85 | 7.727273 |
| Oklahoma | 2 | 19 | 25 | 5.000000 |
| Pennsylvania | 35 | 63 | 168 | 8.842105 |
| South Carolina | 5 | 19 | 34 | 8.500000 |
| Tennessee | 19 | 68 | 125 | 6.944444 |
| Texas | 29 | 62 | 149 | 9.312500 |
| Utah | 0 | 4 | 4 | 4.000000 |
| Virginia | 2 | 17 | 23 | 5.750000 |
| Washington | 4 | 9 | 21 | 7.000000 |
| Wisconsin | 1 | 16 | 19 | 4.750000 |
From this table, It seems that Califolnia, Florida and Illinois are three the most impacted states. However, these states have large population, so we cannot decide that these states are dangerous. New York has also large population but its impact value is small.
The most impacted incident was Pompano Beach (Parkland) in Florida on February 14, 2018. The number of died people were 17 and 17 got injured. The impact of the shooting was very huge and have reverberated far beyond school, Marjory Stoneman Douglas High in Parkland, Fla., as schools around the nation closed Friday, or canceled activities after receiving threats. A teacher in Denver said she moved items from a closet in her classroom “to make more space for 9-year-olds to hide.”
from New York Times, ‘How Did This Happen?’: Grief and Fury After Florida Shooting
This is an interactive map. When your mouse is on the marker, it shows the number of victims, and when you click it, it shows the date incident occured.